home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Original Shareware 1.1
/
The Original Shareware (WeMake CDs)(Volume 1.1)(CDs, Inc)(1993).iso
/
16
/
wputil.zip
/
DB2WPSF.PRG
< prev
next >
Wrap
Text File
|
1985-11-15
|
2KB
|
74 lines
************************* DB2WPSF.PRG ******************************
*
* DB2WPSF.PRG generates a word processing file for Word Perfect
* from the ATLANTIS2 inquiry file for inquiries at least
* 30 days old..
* It creates a files called <filename>.TXT which is then
* to be filtered through db2wpsf.com (db2wpsf.c).
* [of course your set up code,dbf and ndx files will be
* your own.]
*******************************************************************
CLEAR
CLOSE DATABASES
SELECT 1
USE ATINQ INDEX ATINQ
SELECT 2
USE ATCRSGEN INDEX ATCRSGEN * erase old .sf files
SELECT 1 * " "
IF FILE('INQ30OW.SF') * " "
ERASE INQ30OW.SF * " "
ENDIF * " "
IF FILE('INQ30OTH.SF') * " "
ERASE INQ30OTH.SF * " "
ENDIF
* DO THE OW FILE
SET ALTER TO INQ30OW.TXT * the name of your desired filename.ext
SET ALTER ON
DO WHILE .NOT. EOF()
SET RELATION TO INQTYP INTO ATCRSGEN
IF INQTYP = 'OW'.AND. INQDA <= DATE() - 30 .AND. OD30REP <> 'Y' .AND.;
CNVT <> 'Y'
?? TRIM(TITLE) - CHR(18)
?? TRIM(FIRST) - CHR(18)
?? TRIM(LAST) - CHR(18)
?? TRIM(ADDR) - CHR(18)
?? TRIM(CITY) - CHR(18)
?? TRIM(STATE) - CHR(18)
?? TRIM(ZIP) - CHR(18)
?? TRIM(B->FNAME) - CHR(18)
?? DTOC(INQDA) - CHR(18)
?? CHR(5)
ENDIF
SKIP
ENDDO
SET ALTER OFF
SET ALTER TO
GO TOP
SET ALTER TO INQ30OTH.TXT
SET ALTER ON
DO WHILE .NOT. EOF()
SET RELATION TO INQTYP INTO ATCRSGEN
IF INQTYP <> 'OW' .AND. INQDA <= DATE() - 30 .AND. OD30REP <> 'Y' .AND.;
CNVT <> 'Y'
?? TRIM(TITLE) - CHR(18)
?? TRIM(FIRST) - CHR(18)
?? TRIM(LAST) - CHR(18)
?? TRIM(ADDR) - CHR(18)
?? TRIM(CITY) - CHR(18)
?? TRIM(STATE) - CHR(18)
?? TRIM(ZIP) - CHR(18)
?? TRIM(B->FNAME) - CHR(18)
?? DTOC(INQDA) - CHR(18)
?? CHR(5)
ENDIF
SKIP
ENDDO
SET ALTER OFF
SET ALTER TO
* SET OD30REP FLAG
IF INQTYP <> 'OW' .AND. INQDA <= DATE() - 30 .AND. OD30REP <> 'Y' .AND.;
CNVT <> 'Y'
REPLACE ALL OD30REP WITH 'Y' FOR INQDA <= DATE() - 30 .AND. OD30REP <> 'Y';
.AND. CNVT <> 'Y'